02-08-04

Please be sure to read the README.1ST file.

   Basically I've used a bit of VBA to do everything complex, and unfortunately inside of Access it does have its limitations.  For instance, I could not use an array for the filters, so it is a little more tedious to add more filters that I would have liked (but I think my alternative works well:).  I've (sort-of, and very few, I hate documentation;) placed some comments in the code, hopefully those along with the variable names will make things clear enough for everyone.  Yes, I know I didn't use the "industry standards" for my variable names, but then I'm a non-conformist, even sometimes when it hurts!  
   
   If you read through the README you've noted that I could not use arrays, if someone knows away around this problem, please feel free to enlighten me!  Also, I could not find a way to let the user click on the Power Name (like Blades/Claws/Fangs) itself, without screwing up the power's color in the field, and trust me, I tried everything I could think of (enable field, but lock it; disable field but unlock it; etc., etc.).  I would like to keep everything in two separate DBs so that just the interface can be updated, zipped and emailed without having to include all of the data.  Also, it may make it easier if someone wants to convert the front-end to VB or VB.NET (hint, hint).  I have included some default (read "Access created") forms for editing the DB tables directly should someone want to create a menu and add selections for just using the DB and maintaining/updating individual tables, etc.  
   
Known Bugs/Problems:

   - When you click either the "Own + 1" or "Own - 1" buttons on the first hero in the list, it accurately records it in the DB, however, when you click in the main list afterward, an error message pops up to the effect that "the data has changed ... re-edit the record"

   - To display the photos of the HeroClix I made up my own sort-of "algorithm" and only lightly tested it.  It seems to work OK, but since HCRealms member Cheng's pictures only has one photo per std. HeroClix I had to come up with something to show each figure's picture.
   
   - Clicking inside of one of the powers fields screws up the power's color (you must only click on the power label instead)

   - I stink at documentation, so I'm hoping the little I did do and the variable names will be enough to get people going


Things to be done/added

   - Add version numbering!
